Machine Ulitilization

Project Brief:

You have been engaged as a Data Science consultant by a coal terminal. They would like you to investigate one of their heavy machines - RL1 You have been supplied one month worth of data for all of their machines. The dataset shows what percentage of capacity for each machine was idle (unused) in any given hour.

You are required to deliver an R list with the following components:

  1. Character: Machine name
  2. Vector: (min, mean, max) utilisation for the month (excluding unknown hours)
  3. Logical: Has utilisation ever fallen below 90%? TRUE / FALSE
  4. Vector: All hours where utilisation is unknown (NA’s)
  5. Dataframe: For this machine
  6. Plot: For all machines

Machines with Unknown Idles

Machine Hours Unkown
RL1 7
RL2 7
SR1 110
SR4A 230
SR6 7

Machines with Idle Time below 90%

Machine Instances under 90%
RL1 27
SR6 23

All Machines Plot: